home *** CD-ROM | disk | FTP | other *** search
/ SGI Freeware 1999 August / SGI Freeware 1999 August.iso / dist / fw_gnats.idb / usr / freeware / lib / gnats / contrib / sql / Iprms.summwk.z / Iprms.summwk
Encoding:
Text File  |  1999-04-16  |  632 b   |  29 lines
  1. #!/bin/sh
  2.  
  3. # set up
  4.  
  5. PATH=.:/bin:/usr/bin:/usr/unsupported/bin:/usr/unsupported/informix/bin
  6. INFORMIXDIR=/usr/unsupported/informix
  7. DBPATH=/users/db/infx
  8. DBTEMP=/tmp
  9. MAIL=/usr/ucb/mail
  10.  
  11. export PATH
  12. export INFORMIXDIR
  13. export DBPATH
  14. export DBTEMP
  15.  
  16. BUGDIR=/users/db/reports
  17. INFX=/usr/unsupported/informix/bin
  18.  
  19. # ------------------------------------------------------------------------
  20. # select summary data for week and update history
  21. # ------------------------------------------------------------------------
  22.  
  23. cd $DBPATH
  24. $INFX/fglgo summ_wk
  25.  
  26. $INFX/isql engdb cust_rev.sql | $MAIL manager
  27. $INFX/isql engdb engr_rev.sql | $MAIL manager
  28.  
  29.